Entity Relationships - Contact Log (CONTACTLOG)
Related Tables
| Table Name | Table Description | Primary Keys | Usually Joins From | Join Type | Joins On | Details |
|---|---|---|---|---|---|---|
| CONTACTLOG | Contact Log | CONTACTLOGID | Stores details of various forms of contact between Maytas users, trainees, assessors and employers. | |||
| CONTACTLOGFILES | Contact Log Files | FILEID, CONTACTLOGID | CONTACTLOG | One to many | CONTACTLOGID | Lists files associated with each contact log item. |
| TRAINEE | Trainee Basic Details | TRAINEEID | CONTACTLOG | Many to one | TRAINEEID | Stores basic details about each trainee. |
| ASSESSOR | Assessor Details | ASSESSORID | CONTACTLOG | Many to one | ASSESSORID | Stores basic details about each assessor. |
| EMPLOYER | Employer Details | EMPLOYERID | CONTACTLOG | Many to one | EMPLOYERID | Stores basic details about each employer. |
| M32$_USERS | User Details | USERID | CONTACTLOG | Many to one | USERID | Stores basic details about each Maytas user. |